Change the way data is shown in a chart

1. Click the chart.
2. On the Chart menu, click Source Data, and then click the Data Range tab.
3. Click Series in rows or Series in columns.

When the range of values for different data series in a 2-D chart varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.

1. Click the data series you want to plot along a secondary value axis.
2. On the Format menu, click Selected Data Series, and then click the Axis tab.
3. Click Secondary axis.

You can reverse the plotting order of categories or values for most charts, as well as of data series for 3-D charts with a third axis. You cannot reverse the plotting order of values in a radar chart.

1. Click the axis for the categories, values, or series whose plotting order you want to change.
2. On the Format menu, click Selected Axis, and then click the Scale tab.
3. To reverse the plotting order, do one of the following:
   • For categories, select the Categories in reverse order check box.

   • For values, select the Values in reverse order check box.

   • For series in 3-D charts, select the Series in reverse order check box.

1. Click the chart.
2. On the Tools menu, click Options, and then click the Chart tab.
3. Under Plot empty cells as, click the option you want.

1. Click a slice in the pie chart you want to change.
2. On the Format menu, click Selected Data Point, and then click the Options tab.
3. Select the options you want.

Tip

1. Click a data series in the chart you want to change.

   To change the plotting order of data series in a surface chart, click a legend key.

2. On the Format menu, click Selected Data Series or Selected Legend Key, and then click the Series Order tab.
3. In the Series order box, click the series you want to move.
4. To place the series in the order you want, click Move Up or Move Down.